﻿CREATE TABLE [dbo].[RunningJob] (
    [RunningJobID]   INT              NOT NULL,
    [PercentageDone] INT              NULL,
    [Status]         VARCHAR (50)     NULL,
    [StartTime]      DATETIME         NULL,
    [JobDefnitionID] UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_RunningJob_1] PRIMARY KEY CLUSTERED ([RunningJobID] ASC),
    CONSTRAINT [FK_RunningJob_JobDefinition] FOREIGN KEY ([JobDefnitionID]) REFERENCES [dbo].[JobDefinition] ([JobDefinitionID])
);

